﻿insert into EnderecoTipo VALUES (1,'Rua')
insert into EnderecoTipo VALUES (2,'Avenida') 
insert into EnderecoTipo VALUES (3,'Alameda') 
insert into EnderecoTipo VALUES (4,'Travessa') 

insert into Estado vALUES('SP','São Paulo')
insert into Estado vALUES('RJ','Rio de Janeiro')
insert into Estado vALUES('MG','Minas Gerais')
insert into Estado vALUES('ES','Espirito Santo')
insert into Estado vALUES('PR','Paraná')
insert into Estado vALUES('SC','Santa Catarina')
insert into Estado vALUES('RS','Rio Grande do Sul')

INSERT INTO Aluno VALUES (1,'DANIEL DA CUNHA BUENO','1983/05/17',GETDATE(),1,'danielbueno_@hotmail.com','')
INSERT INTO Aluno VALUES (2,'DALTON EDUARDO DA SILVEIRA','1989/08/24',GETDATE(),1,'edu_dalton@hotmail.com','')
INSERT INTO Aluno VALUES (3,'ANDRÉ DA CUNHA BUENO','1993/11/17',GETDATE(),1,'andrecbueno@hotmail.com','')
INSERT INTO Aluno VALUES ((select isnull(max(alunoid),0) + 1 from aluno where afiliadoid=1),'FELIPE DA CUNHA BUENO','1993/11/17',GETDATE(),1,'felipecbueno@hotmail.com','')
INSERT INTO Aluno VALUES ((select isnull(max(alunoid),0) + 1 from aluno where afiliadoid=1),'JOÃO DA CUNHA BUENO','1993/11/17',GETDATE(),1,'joaocbueno@egym.com','')
INSERT INTO Aluno VALUES ((select isnull(max(alunoid),0) + 1 from aluno where afiliadoid=1),'HENRIQUE DA CUNHA BUENO','1993/11/17',GETDATE(),1,'henriquecbueno@egym.com','')
INSERT INTO Aluno VALUES ((select isnull(max(alunoid),0) + 1 from aluno where afiliadoid=1),'MARCELO DA CUNHA BUENO','1993/11/17',GETDATE(),1,'marcelocbueno@egym.com','')
INSERT INTO Aluno VALUES ((select isnull(max(alunoid),0) + 1 from aluno where afiliadoid=1),'RAFAEL DA CUNHA BUENO','1993/11/17',GETDATE(),1,'rafaelcbueno@v.com','')
INSERT INTO Aluno VALUES ((select isnull(max(alunoid),0) + 1 from aluno where afiliadoid=1),'OTÁVIO DA CUNHA BUENO','1993/11/17',GETDATE(),1,'otaviocbueno@egym.com','')
INSERT INTO Aluno VALUES ((select isnull(max(alunoid),0) + 1 from aluno where afiliadoid=1),'ROBERTO DA CUNHA BUENO','1993/11/17',GETDATE(),1,'robertocbueno@egym.com','')
INSERT INTO Aluno VALUES ((select isnull(max(alunoid),0) + 1 from aluno where afiliadoid=1),'CARLOS DA CUNHA BUENO','1993/11/17',GETDATE(),1,'carloscbueno@egym.com','')
INSERT INTO Aluno VALUES ((select isnull(max(alunoid),0) + 1 from aluno where afiliadoid=1),'JOSÉ DA CUNHA BUENO','1993/11/17',GETDATE(),1,'josecbueno@egym.com','')
INSERT INTO Aluno VALUES ((select isnull(max(alunoid),0) + 1 from aluno where afiliadoid=1),'ALESSANDRO DA CUNHA BUENO','1993/11/17',GETDATE(),1,'alessandrocbueno@egym.com','')
INSERT INTO Aluno VALUES ((select isnull(max(alunoid),0) + 1 from aluno where afiliadoid=1),'ALEX DA CUNHA BUENO','1993/11/17',GETDATE(),1,'alexcbueno@egym.com','')
INSERT INTO Aluno VALUES ((select isnull(max(alunoid),0) + 1 from aluno where afiliadoid=1),'EVANDRO DA CUNHA BUENO','1993/11/17',GETDATE(),1,'evandrocbueno@egym.com','')
INSERT INTO Aluno VALUES ((select isnull(max(alunoid),0) + 1 from aluno where afiliadoid=1),'MICHEL DA CUNHA BUENO','1993/11/17',GETDATE(),1,'michelcbueno@egym.com','')
INSERT INTO Aluno VALUES ((select isnull(max(alunoid),0) + 1 from aluno where afiliadoid=1),'FLÁVIO DA CUNHA BUENO','1993/11/17',GETDATE(),1,'flaviocbueno@egym.com','')
INSERT INTO Aluno VALUES ((select isnull(max(alunoid),0) + 1 from aluno where afiliadoid=1),'ANDERSON DA CUNHA BUENO','1993/11/17',GETDATE(),1,'andersoncbueno@egym.com','')
INSERT INTO Aluno VALUES ((select isnull(max(alunoid),0) + 1 from aluno where afiliadoid=1),'ANDERSON DA CUNHA BUENO','1993/11/17',GETDATE(),1,'andersoncbueno@egym.com','')
INSERT INTO Aluno VALUES ((select isnull(max(alunoid),0) + 1 from aluno where afiliadoid=1),'GILBERTO DA CUNHA BUENO','1993/11/17',GETDATE(),1,'gilbertocbueno@egym.com','')
INSERT INTO Aluno VALUES ((select isnull(max(alunoid),0) + 1 from aluno where afiliadoid=1),'PAULO DA CUNHA BUENO','1993/11/17',GETDATE(),1,'paulocbueno@egym.com','')
INSERT INTO Aluno VALUES ((select isnull(max(alunoid),0) + 1 from aluno where afiliadoid=1),'VALDIR DA CUNHA BUENO','1993/11/17',GETDATE(),1,'valdircbueno@egym.com','')
INSERT INTO Aluno VALUES ((select isnull(max(alunoid),0) + 1 from aluno where afiliadoid=1),'VLADIMIR DA CUNHA BUENO','1993/11/17',GETDATE(),1,'vladimircbueno@egym.com','')
INSERT INTO Aluno VALUES ((select isnull(max(alunoid),0) + 1 from aluno where afiliadoid=1),'SANCHEZ DA CUNHA BUENO','1993/11/17',GETDATE(),1,'sanchezcbueno@egym.com','')
INSERT INTO Aluno VALUES ((select isnull(max(alunoid),0) + 1 from aluno where afiliadoid=1),'VANDERLEI DA CUNHA BUENO','1993/11/17',GETDATE(),1,'vanderleicbueno@egym.com','')
INSERT INTO Aluno VALUES ((select isnull(max(alunoid),0) + 1 from aluno where afiliadoid=1),'MARCOS DA CUNHA BUENO','1993/11/17',GETDATE(),1,'marcoscbueno@egym.com','')
INSERT INTO Aluno VALUES ((select isnull(max(alunoid),0) + 1 from aluno where afiliadoid=1),'antonio DA CUNHA BUENO','1993/11/17',GETDATE(),1,'antoniocbueno@egym.com','')

